|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Phoebus ApolloX
Reasonable People
Of Sound Mind
1
   |
Posted - 2011.09.16 14:18:00 -
[1] - Quote
Hey, first of all good work so far this project is pretty good. I did however run into a couple hiccups that I figure I'd post about while it's still fresh.
Problem 1: I disabled TS3 server features as my TS3 host doesn't seem to have a place to access and edit my whitelist, and TS3 registration isn't a huge deal to me. However every time the replace SQL query would run to add a new api key it'd eliminate the previous key, forcing me to keep only one key in the database at a time. I checked and rechecked, tried different query methods, and no dice. Found out after a lot of fiddling that the key for the TS UID is set to "unique", and every record I'd attempt to add was adding it with a value of "NULL", which was making the MySQL server gurgle. I changed that database column to "index" and I believe that has fixed my problem (still testing).
Problem 2: After letting someone test it out, they would get added to the right group but not be able to see the forums. It seems they were cached with the permissions prior to the edit, and having them relog didn't update their forum permissions. I found that by setting user_permissions to blank in check-users.php with a query just after the "setting default forums group" query, this fixed that problem. Here is the query I added.
edited out: the three less than signs before the first EOL
Quote: $query = (less than signs go here)EOL
UPDATE {$config['Forums DB']['Table Prefix']}users
SET user_permissions = ""
WHERE user_id = {$forums_user['ID']}
EOL;
mysql_query($query) or log_message('Error clearing user_permissions. User: ' . $forums_user['Username']);
I also want to note that I am on php 5.2 and that with the current iteration of the code replacing all the 'EOL' with EOL definitely works just fine. |
Phoebus ApolloX
Reasonable People
Of Sound Mind
1
|
Posted - 2011.09.17 21:28:00 -
[2] - Quote
I ran into an unexpected behavior. The updating bot script seems to add people to the correct forum group, but when API keys get deleted or characters with a valid API get booted from corp it doesn't seem to be removing them from the group. I let the script run overnight in case it's just a cache issue.
I haven't looked too far into it yet, but I'd appreciate any suggestions in pinning down the problem. I've updated the script to the version last supplied. |
Phoebus ApolloX
Reasonable People
Of Sound Mind
1
|
Posted - 2011.09.18 00:31:00 -
[3] - Quote
How old does cache time need to be before it runs a check? |
Phoebus ApolloX
Reasonable People
Of Sound Mind
1
|
Posted - 2011.09.18 01:33:00 -
[4] - Quote
As an update, the updated code must have fixed the issue because everything did boot automatically that should've. It might be useful to still know how old a cache must be out of date before it re-checks, though. |
|
|
| |
|